Pivot Table Definition - Pathways: Inquiry to Consult Conversion

If you are diligently using treatment pathways, this table show your inquiry to consult conversion rates. For additional information, check out Pivot Tables - Defining the Elements.

Note: This table does not give you monthly totals. It is designed to show a total over a period of time. Since there are 3 referral source/detail combinations for each treatment pathway, you may select them as filters before you generate the table, but they do not show in the report results.

This report includes canceled appointments in the Booked number. The purpose of this is for you to see the # Attended and % Attended and evaluate whether your non-attendance (including cancellations) is too high.

Initial Data Set

Any treatment pathway where the

  • the treatment pathway date (not create date) is in the date range
  • the treatment pathway is not deleted AND
  • the patient is not deleted

For the treatment pathways above, any appointment where the

  • Appointment Type has the "Consult" box checked AND
  • the appointment date (not create date) is after the treatment pathway date AND
  • the appointment is not deleted

Filter Selection Before Generate

  • Appointment Date Range
  • Procedures of Interest
  • Referral Sources
  • Referral Details

Default Filters

  • Coordinator
  • Consult Appointment Type

Optional Filters

  • Provider
  • Facility
  • Treatment Pathway

Report Results

Note: Days to Book = create date of consult appointment minus the treatment pathway date

  • # Consults = Count of treatment pathways
  • Not Booked = Count of New Pathways where there is no subsequent consult appointment scheduled
  • % Booked = Not Booked divided by New Pathways expressed as a %
  • # Booked = Count of New Pathways where there is a subsequent consultappointment scheduled
  • % Booked = Not Booked divided by New Pathways expressed as a %
  • Same Day = Days to Book = 0
  • < = 1 Week = Days to Book < = 7
  • 2 Weeks = Days to Book > 7 AND <= 14
  • 3 Weeks = Days to Book > 14 AND <= 21
  • 4 Weeks = Days to Book > 21 AND <= 28
  • 2 Months = Days to Book > 28 AND <= 60
  • 3 Months = Days to Book > 61 AND <= 90
  • 6 Months = Days to Book > 91 AND <= 180
  • 9 Months = Days to Book > 181 AND <= 270
  • 12 Months = Days to Book > 270 AND <= 365
  • # Attended = Count of # Consults where the consult appointment is checked in
  • % Attended = # Attended divided by # Consults expressed as a %

Pivot Detail Fields

Patients | Registration / Billing, Patient Information Tab

  • Patient Name (Last, First Middle)
  • Patient Date of Birth
  • Patient Age
  • Patient Gender
  • Procedure(s) of Interest
  • Treatment Pathway

From the consult appointment

  • Provider
  • Facility
  • Coordinator
  • Appointment Type
  • Appointment Date
  • Appointment Create Date
  • Appointment Date
  • Appointment Checked In Date
  • Days to Book